-- Shows approved if Invoice is Validated.
SELECT *
FROM (SELECT aia.invoicenum
,apinvoicespkg.getapprovalstatus
(aia.invoiceid,
aia.invoiceamount,
aia.paymentstatusflag,
aia.invoicetypelookupcode
) status
FROM apinvoicesall aia) inv
WHERE inv.status = 'APPROVED'